﻿/*
#**************************************************************************
#  openSIS is a student information system for public and non-public 
#  schools from Open Solutions for Education, Inc. web: www.os4ed.com
#
#  openSIS is  web-based, open source, and comes packed with features that 
#  include student demographic info, scheduling, grade book, attendance, 
#  report cards, eligibility, transcripts, parent portal, 
#  student portal and more.   
#
#  Visit the openSIS web site at http://www.opensis.com to learn more.
#  If you have question regarding this system or the license, please send 
#  an email to info@os4ed.com.
#
#  This program is released under the terms of the GNU General Public License  
#  as  published by the Free Software Foundation, version 2 of the License. 
#  See license.txt.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#**************************************************************************** 

*/

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using OpenSISDataConnection;
using OpenSISDropDownBusinessLogic;

namespace OpenSISDropDownDataLayer
{
    public class DropDownDL
    {
        public DataSet PopulateSchool()
        {
            DataSet ds = null;
            ds = DataConnection.ConnectionPath.Getdata("select * from schools");
            return ds;
        }

        public DataSet PopulateFullYear(DropDownBL school)
        {
            DataSet ds = null;
            ds = DataConnection.ConnectionPath.Getdata("select SMP.schyr_id,SMP.sch_mp_name,SY.schyr_nm from sch_marking_periods SMP inner join school_years SY on SMP.schyr_id=SY.schyr_id inner join year_type YT on SY.years_type_id =YT.years_type_id where SMP.sch_id=" + school.Sch_ID + " and YT.year_type_cd ='Y'");
            return ds;
        }

        public DataSet PopulateLevel1(DropDownBL school)
        {
            DataSet ds = null;
            ds = DataConnection.ConnectionPath.Getdata("select SMP.schyr_id,SMP.sch_mp_name from sch_marking_periods SMP inner join school_years SY on SMP.schyr_id=SY.schyr_id inner join year_type YT on SY.years_type_id =YT.years_type_id where SMP.sch_id=" + school.Sch_ID + " and SY.schyr_year=" + school.Sch_Year + " and YT.years_type_id=2");
            return ds;
        }

        public DataSet PopulateState()
        {
            DataSet ds = null;
            ds = DataConnection.ConnectionPath.Getdata("select * from look_up_data where type=2");
            return ds;
        }

        public DataSet PopulateCountry() 
        {
            DataSet ds = null;

            ds = DataConnection.ConnectionPath.Getdata("select * from look_up_data where type=1");
            return ds;
        }
    }
}
